USE [aspnetdb]
GO


-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetTempUsers
AS
BEGIN
	SELECT [User1].[user1_name],[User1].[role_id],  [User1].[request], [User1].[requested_position]
	FROM [User1]
	WHERE [User1].[role_id]=1
END
